Pandas Profiling Report

Dataset statistics

Number of variables	21
Number of observations	3256
Missing cells	11
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	489.8 KiB
Average record size in memory	154.0 B

Variable types

Numeric	9
Categorical	10
Boolean	2

Alerts

`Case_Number` has a high cardinality: 3256 distinct values	High cardinality
`Date` has a high cardinality: 1642 distinct values	High cardinality
`Block` has a high cardinality: 2761 distinct values	High cardinality
`IUCR` has a high cardinality: 158 distinct values	High cardinality
`Description` has a high cardinality: 146 distinct values	High cardinality
`Location_Description` has a high cardinality: 73 distinct values	High cardinality
`Location` has a high cardinality: 3092 distinct values	High cardinality
`ID` is highly overall correlated with `Primary_Type` and 2 other fields	High correlation
`Beat` is highly overall correlated with `District` and 6 other fields	High correlation
`District` is highly overall correlated with `Beat` and 6 other fields	High correlation
`Ward` is highly overall correlated with `Beat` and 4 other fields	High correlation
`Community_Area` is highly overall correlated with `Beat` and 4 other fields	High correlation
`X_Coordinate` is highly overall correlated with `Beat` and 4 other fields	High correlation
`Y_Coordinate` is highly overall correlated with `Beat` and 6 other fields	High correlation
`Latitude` is highly overall correlated with `Beat` and 6 other fields	High correlation
`Longitude` is highly overall correlated with `Beat` and 4 other fields	High correlation
`Primary_Type` is highly overall correlated with `ID` and 4 other fields	High correlation
`Arrest` is highly overall correlated with `Primary_Type` and 1 other fields	High correlation
`Domestic` is highly overall correlated with `Primary_Type` and 1 other fields	High correlation
`FBI_Code` is highly overall correlated with `ID` and 4 other fields	High correlation
`Updated_On` is highly overall correlated with `ID` and 2 other fields	High correlation
`Updated_On` is highly imbalanced (96.3%)	Imbalance
`Case_Number` is uniformly distributed	Uniform
`Block` is uniformly distributed	Uniform
`Location` is uniformly distributed	Uniform
`ID` has unique values	Unique
`Case_Number` has unique values	Unique

Reproduction

Analysis started	2023-04-14 23:09:51.498769
Analysis finished	2023-04-14 23:10:10.607133
Duration	19.11 seconds
Software version	ydata-profiling vv4.1.2
Download configuration	config.json

ID
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	3256
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7539492

Minimum	4785
Maximum	7588414
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	25.6 KiB

Quantile statistics

Minimum	4785
5-th percentile	7583757.8
Q1	7584795.8
median	7585953.5
Q3	7587392.2
95-th percentile	7588218.2
Maximum	7588414
Range	7583629
Interquartile range (IQR)	2596.5

Descriptive statistics

Standard deviation	592440.28
Coefficient of variation (CV)	0.078578275
Kurtosis	158.04868
Mean	7539492
Median Absolute Deviation (MAD)	1336
Skewness	-12.647158
Sum	2.4548586 × 10¹⁰
Variance	3.5098548 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4785	1	< 0.1%
7587064	1	< 0.1%
7587051	1	< 0.1%
7587054	1	< 0.1%
7587055	1	< 0.1%
7587056	1	< 0.1%
7587057	1	< 0.1%
7587058	1	< 0.1%
7587059	1	< 0.1%
7587060	1	< 0.1%
Other values (3246)	3246	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4785	1	< 0.1%
4786	1	< 0.1%
4787	1	< 0.1%
4788	1	< 0.1%
4789	1	< 0.1%
4790	1	< 0.1%
4791	1	< 0.1%
4792	1	< 0.1%
4793	1	< 0.1%
4794	1	< 0.1%

Value	Count	Frequency (%)
7588414	1	< 0.1%
7588413	1	< 0.1%
7588412	1	< 0.1%
7588411	1	< 0.1%
7588408	1	< 0.1%
7588407	1	< 0.1%
7588406	1	< 0.1%
7588405	1	< 0.1%
7588404	1	< 0.1%
7588403	1	< 0.1%

Case_Number
Categorical

HIGH CARDINALITY UNIFORM UNIQUE

Distinct	3256
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	25.6 KiB

HP610824	1
HS390683	1
HS390635	1
HS390464	1
HS390588	1
Other values (3251)	3251

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	26048
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3256 ?
Unique (%)	100.0%

Sample

1st row	HP610824
2nd row	HP616595
3rd row	HP616904
4th row	HP618616
5th row	HP619020

Common Values

Value	Count	Frequency (%)
HP610824	1	< 0.1%
HS390683	1	< 0.1%
HS390635	1	< 0.1%
HS390464	1	< 0.1%
HS390588	1	< 0.1%
HS390494	1	< 0.1%
HS390658	1	< 0.1%
HS390682	1	< 0.1%
HS390674	1	< 0.1%
HS390646	1	< 0.1%
Other values (3246)	3246	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
hp610824	1	< 0.1%
hp623937	1	< 0.1%
hs387357	1	< 0.1%
hs368462	1	< 0.1%
hp616904	1	< 0.1%
hp618616	1	< 0.1%
hp619020	1	< 0.1%
hp620131	1	< 0.1%
hp620406	1	< 0.1%
hp622040	1	< 0.1%
Other values (3246)	3246	99.7%

Most occurring characters

Value	Count	Frequency (%)
3	4220	16.2%
8	3397	13.0%
H	3256	12.5%
S	3223	12.4%
9	2788	10.7%
7	1591	6.1%
1	1550	6.0%
0	1469	5.6%
2	1253	4.8%
6	1151	4.4%
Other values (4)	2150	8.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	19536	75.0%
Uppercase Letter	6512	25.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
3	4220	21.6%
8	3397	17.4%
9	2788	14.3%
7	1591	8.1%
1	1550	7.9%
0	1469	7.5%
2	1253	6.4%
6	1151	5.9%
4	1070	5.5%
5	1047	5.4%

Uppercase Letter

Value	Count	Frequency (%)
H	3256	50.0%
S	3223	49.5%
P	20	0.3%
R	13	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	19536	75.0%
Latin	6512	25.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
3	4220	21.6%
8	3397	17.4%
9	2788	14.3%
7	1591	8.1%
1	1550	7.9%
0	1469	7.5%
2	1253	6.4%
6	1151	5.9%
4	1070	5.5%
5	1047	5.4%

Latin

Value	Count	Frequency (%)
H	3256	50.0%
S	3223	49.5%
P	20	0.3%
R	13	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	26048	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
3	4220	16.2%
8	3397	13.0%
H	3256	12.5%
S	3223	12.4%
9	2788	10.7%
7	1591	6.1%
1	1550	6.0%
0	1469	5.6%
2	1253	4.8%
6	1151	4.4%
Other values (4)	2150	8.3%

Date
Categorical

Distinct	1642
Distinct (%)	50.4%
Missing	0
Missing (%)	0.0%
Memory size	25.6 KiB

06/30/2010 07:00:00 PM	25
06/30/2010 08:00:00 PM	22
07/01/2010 02:00:00 PM	21
07/01/2010 12:00:00 PM	20
06/30/2010 10:00:00 PM	20
Other values (1637)	3148

Length

Max length	22
Median length	22
Mean length	22
Min length	22

Characters and Unicode

Total characters	71632
Distinct characters	16
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1122 ?
Unique (%)	34.5%

Sample

1st row	10/07/2008 12:39:00 PM
2nd row	10/09/2008 03:30:00 AM
3rd row	10/09/2008 08:35:00 AM
4th row	10/10/2008 02:33:00 AM
5th row	10/10/2008 12:50:00 PM

Common Values

Value	Count	Frequency (%)
06/30/2010 07:00:00 PM	25	0.8%
06/30/2010 08:00:00 PM	22	0.7%
07/01/2010 02:00:00 PM	21	0.6%
07/01/2010 12:00:00 PM	20	0.6%
06/30/2010 10:00:00 PM	20	0.6%
07/02/2010 10:00:00 PM	19	0.6%
07/02/2010 12:00:00 PM	18	0.6%
07/01/2010 01:00:00 PM	17	0.5%
07/02/2010 07:00:00 PM	17	0.5%
06/30/2010 09:00:00 PM	16	0.5%
Other values (1632)	3061	94.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pm	2117	21.7%
am	1139	11.7%
07/01/2010	889	9.1%
07/02/2010	740	7.6%
06/30/2010	593	6.1%
07/03/2010	328	3.4%
06/29/2010	134	1.4%
10:00:00	130	1.3%
12:00:00	105	1.1%
09:00:00	100	1.0%
Other values (630)	3493	35.8%

Most occurring characters

Value	Count	Frequency (%)
0	24741	34.5%
/	6512	9.1%
	6512	9.1%
:	6512	9.1%
1	6412	9.0%
2	5557	7.8%
M	3256	4.5%
7	2405	3.4%
P	2117	3.0%
3	1982	2.8%
Other values (6)	5626	7.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	45584	63.6%
Other Punctuation	13024	18.2%
Space Separator	6512	9.1%
Uppercase Letter	6512	9.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	24741	54.3%
1	6412	14.1%
2	5557	12.2%
7	2405	5.3%
3	1982	4.3%
6	1562	3.4%
5	1204	2.6%
4	717	1.6%
9	532	1.2%
8	472	1.0%

Uppercase Letter

Value	Count	Frequency (%)
M	3256	50.0%
P	2117	32.5%
A	1139	17.5%

Other Punctuation

Value	Count	Frequency (%)
/	6512	50.0%
:	6512	50.0%

Space Separator

Value	Count	Frequency (%)
	6512	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	65120	90.9%
Latin	6512	9.1%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	24741	38.0%
/	6512	10.0%
	6512	10.0%
:	6512	10.0%
1	6412	9.8%
2	5557	8.5%
7	2405	3.7%
3	1982	3.0%
6	1562	2.4%
5	1204	1.8%
Other values (3)	1721	2.6%

Latin

Value	Count	Frequency (%)
M	3256	50.0%
P	2117	32.5%
A	1139	17.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	71632	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	24741	34.5%
/	6512	9.1%
	6512	9.1%
:	6512	9.1%
1	6412	9.0%
2	5557	7.8%
M	3256	4.5%
7	2405	3.4%
P	2117	3.0%
3	1982	2.8%
Other values (6)	5626	7.9%

Block
Categorical

HIGH CARDINALITY UNIFORM

Distinct	2761
Distinct (%)	84.8%
Missing	0
Missing (%)	0.0%
Memory size	25.6 KiB

0000X N STATE ST	11
001XX W 87TH ST	7
008XX N MICHIGAN AVE	7
038XX W NORTH AVE	5
063XX S DR MARTIN LUTHER KING JR DR	5
Other values (2756)	3221

Length

Max length	35
Median length	25
Mean length	18.507985
Min length	14

Characters and Unicode

Total characters	60262
Distinct characters	37
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2363 ?
Unique (%)	72.6%

Sample

1st row	000XX E 75TH ST
2nd row	048XX W POLK ST
3rd row	030XX W MANN DR
4th row	052XX W CHICAGO AVE
5th row	026XX S HOMAN AVE

Common Values

Value	Count	Frequency (%)
0000X N STATE ST	11	0.3%
001XX W 87TH ST	7	0.2%
008XX N MICHIGAN AVE	7	0.2%
038XX W NORTH AVE	5	0.2%
063XX S DR MARTIN LUTHER KING JR DR	5	0.2%
042XX S COTTAGE GROVE AVE	5	0.2%
088XX S BURLEY AVE	4	0.1%
0000X W 79TH ST	4	0.1%
033XX W FILLMORE ST	4	0.1%
025XX N NARRAGANSETT AVE	4	0.1%
Other values (2751)	3200	98.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ave	1734	13.0%
s	1324	9.9%
st	1145	8.6%
w	957	7.2%
n	760	5.7%
e	219	1.6%
dr	112	0.8%
0000x	101	0.8%
rd	92	0.7%
blvd	91	0.7%
Other values (771)	6782	50.9%

Most occurring characters

Value	Count	Frequency (%)
	10061	16.7%
X	6450	10.7%
0	4253	7.1%
E	4196	7.0%
A	3926	6.5%
S	3559	5.9%
T	2541	4.2%
N	2530	4.2%
V	2037	3.4%
R	1904	3.2%
Other values (27)	18805	31.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	39380	65.3%
Decimal Number	10821	18.0%
Space Separator	10061	16.7%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
X	6450	16.4%
E	4196	10.7%
A	3926	10.0%
S	3559	9.0%
T	2541	6.5%
N	2530	6.4%
V	2037	5.2%
R	1904	4.8%
L	1684	4.3%
O	1475	3.7%
Other values (16)	9078	23.1%

Decimal Number

Value	Count	Frequency (%)
0	4253	39.3%
1	1263	11.7%
3	799	7.4%
2	780	7.2%
5	752	6.9%
6	685	6.3%
4	677	6.3%
7	647	6.0%
8	513	4.7%
9	452	4.2%

Space Separator

Value	Count	Frequency (%)
	10061	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	39380	65.3%
Common	20882	34.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
X	6450	16.4%
E	4196	10.7%
A	3926	10.0%
S	3559	9.0%
T	2541	6.5%
N	2530	6.4%
V	2037	5.2%
R	1904	4.8%
L	1684	4.3%
O	1475	3.7%
Other values (16)	9078	23.1%

Common

Value	Count	Frequency (%)
	10061	48.2%
0	4253	20.4%
1	1263	6.0%
3	799	3.8%
2	780	3.7%
5	752	3.6%
6	685	3.3%
4	677	3.2%
7	647	3.1%
8	513	2.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	60262	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	10061	16.7%
X	6450	10.7%
0	4253	7.1%
E	4196	7.0%
A	3926	6.5%
S	3559	5.9%
T	2541	4.2%
N	2530	4.2%
V	2037	3.4%
R	1904	3.2%
Other values (27)	18805	31.2%

IUCR
Categorical

Distinct	158
Distinct (%)	4.9%
Missing	0
Missing (%)	0.0%
Memory size	25.6 KiB

486	297
820	228
1811	203
460	203
810	176
Other values (153)	2149

Length

Max length	4
Median length	3
Mean length	3.4097052
Min length	3

Characters and Unicode

Total characters	11102
Distinct characters	15
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	33 ?
Unique (%)	1.0%

Sample

1st row	110
2nd row	110
3rd row	110
4th row	110
5th row	110

Common Values

Value	Count	Frequency (%)
486	297	9.1%
820	228	7.0%
1811	203	6.2%
460	203	6.2%
810	176	5.4%
610	147	4.5%
1320	143	4.4%
1310	135	4.1%
560	131	4.0%
890	114	3.5%
Other values (148)	1479	45.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
486	297	9.1%
820	228	7.0%
1811	203	6.2%
460	203	6.2%
810	176	5.4%
610	147	4.5%
1320	143	4.4%
1310	135	4.1%
560	131	4.0%
890	114	3.5%
Other values (148)	1479	45.4%

Most occurring characters

Value	Count	Frequency (%)
0	2463	22.2%
1	2203	19.8%
8	1375	12.4%
2	1298	11.7%
6	1072	9.7%
4	836	7.5%
3	749	6.7%
5	524	4.7%
9	295	2.7%
7	143	1.3%
Other values (5)	144	1.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10958	98.7%
Uppercase Letter	144	1.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2463	22.5%
1	2203	20.1%
8	1375	12.5%
2	1298	11.8%
6	1072	9.8%
4	836	7.6%
3	749	6.8%
5	524	4.8%
9	295	2.7%
7	143	1.3%

Uppercase Letter

Value	Count	Frequency (%)
A	119	82.6%
P	16	11.1%
B	4	2.8%
R	3	2.1%
C	2	1.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	10958	98.7%
Latin	144	1.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2463	22.5%
1	2203	20.1%
8	1375	12.5%
2	1298	11.8%
6	1072	9.8%
4	836	7.6%
3	749	6.8%
5	524	4.8%
9	295	2.7%
7	143	1.3%

Latin

Value	Count	Frequency (%)
A	119	82.6%
P	16	11.1%
B	4	2.8%
R	3	2.1%
C	2	1.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11102	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2463	22.2%
1	2203	19.8%
8	1375	12.4%
2	1298	11.7%
6	1072	9.7%
4	836	7.5%
3	749	6.7%
5	524	4.7%
9	295	2.7%
7	143	1.3%
Other values (5)	144	1.3%

Primary_Type
Categorical

Distinct	24
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	25.6 KiB

THEFT	672
BATTERY	605
NARCOTICS	404
CRIMINAL DAMAGE	304
BURGLARY	241
Other values (19)	1030

Length

Max length	32
Median length	22
Mean length	9.6464988
Min length	5

Characters and Unicode

Total characters	31409
Distinct characters	25
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	HOMICIDE
2nd row	HOMICIDE
3rd row	HOMICIDE
4th row	HOMICIDE
5th row	HOMICIDE

Common Values

Value	Count	Frequency (%)
THEFT	672	20.6%
BATTERY	605	18.6%
NARCOTICS	404	12.4%
CRIMINAL DAMAGE	304	9.3%
BURGLARY	241	7.4%
OTHER OFFENSE	204	6.3%
ASSAULT	185	5.7%
ROBBERY	143	4.4%
MOTOR VEHICLE THEFT	132	4.1%
DECEPTIVE PRACTICE	119	3.7%
Other values (14)	247	7.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
theft	804	18.2%
battery	605	13.7%
narcotics	404	9.2%
criminal	382	8.7%
damage	304	6.9%
burglary	241	5.5%
offense	229	5.2%
other	204	4.6%
assault	192	4.4%
robbery	143	3.2%
Other values (25)	898	20.4%

Most occurring characters

Value	Count	Frequency (%)
T	4219	13.4%
E	3508	11.2%
A	2977	9.5%
R	2775	8.8%
I	1900	6.0%
C	1802	5.7%
O	1498	4.8%
S	1319	4.2%
F	1286	4.1%
N	1213	3.9%
Other values (15)	8912	28.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	30259	96.3%
Space Separator	1150	3.7%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	4219	13.9%
E	3508	11.6%
A	2977	9.8%
R	2775	9.2%
I	1900	6.3%
C	1802	6.0%
O	1498	5.0%
S	1319	4.4%
F	1286	4.2%
N	1213	4.0%
Other values (14)	7762	25.7%

Space Separator

Value	Count	Frequency (%)
	1150	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	30259	96.3%
Common	1150	3.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	4219	13.9%
E	3508	11.6%
A	2977	9.8%
R	2775	9.2%
I	1900	6.3%
C	1802	6.0%
O	1498	5.0%
S	1319	4.4%
F	1286	4.2%
N	1213	4.0%
Other values (14)	7762	25.7%

Common

Value	Count	Frequency (%)
	1150	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	31409	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	4219	13.4%
E	3508	11.2%
A	2977	9.5%
R	2775	8.8%
I	1900	6.0%
C	1802	5.7%
O	1498	4.8%
S	1319	4.2%
F	1286	4.1%
N	1213	3.9%
Other values (15)	8912	28.4%

Description
Categorical

Distinct	146
Distinct (%)	4.5%
Missing	0
Missing (%)	0.0%
Memory size	25.6 KiB

SIMPLE	337
DOMESTIC BATTERY SIMPLE	297
$500 AND UNDER	228
POSS: CANNABIS 30GMS OR LESS	203
OVER $500	176
Other values (141)	2015

Length

Max length	47
Median length	31
Mean length	16.55344
Min length	6

Characters and Unicode

Total characters	53898
Distinct characters	39
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	29 ?
Unique (%)	0.9%

Sample

1st row	FIRST DEGREE MURDER
2nd row	FIRST DEGREE MURDER
3rd row	FIRST DEGREE MURDER
4th row	FIRST DEGREE MURDER
5th row	FIRST DEGREE MURDER

Common Values

Value	Count	Frequency (%)
SIMPLE	337	10.4%
DOMESTIC BATTERY SIMPLE	297	9.1%
$500 AND UNDER	228	7.0%
POSS: CANNABIS 30GMS OR LESS	203	6.2%
OVER $500	176	5.4%
TO VEHICLE	150	4.6%
FORCIBLE ENTRY	147	4.5%
TO PROPERTY	135	4.1%
FROM BUILDING	114	3.5%
AUTOMOBILE	110	3.4%
Other values (136)	1359	41.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
simple	634	7.6%
500	404	4.9%
to	391	4.7%
poss	363	4.4%
domestic	314	3.8%
battery	314	3.8%
under	239	2.9%
entry	233	2.8%
or	231	2.8%
and	228	2.7%
Other values (217)	4968	59.7%

Most occurring characters

Value	Count	Frequency (%)
E	5358	9.9%
	5063	9.4%
T	3581	6.6%
S	3389	6.3%
O	3389	6.3%
R	3275	6.1%
A	3235	6.0%
I	3091	5.7%
N	3088	5.7%
L	2356	4.4%
Other values (29)	18073	33.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	45489	84.4%
Space Separator	5063	9.4%
Decimal Number	1768	3.3%
Other Punctuation	908	1.7%
Currency Symbol	436	0.8%
Dash Punctuation	104	0.2%
Open Punctuation	65	0.1%
Close Punctuation	65	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	5358	11.8%
T	3581	7.9%
S	3389	7.5%
O	3389	7.5%
R	3275	7.2%
A	3235	7.1%
I	3091	6.8%
N	3088	6.8%
L	2356	5.2%
M	1903	4.2%
Other values (15)	12824	28.2%

Other Punctuation

Value	Count	Frequency (%)
:	655	72.1%
/	206	22.7%
,	30	3.3%
&	11	1.2%
.	6	0.7%

Decimal Number

Value	Count	Frequency (%)
0	1102	62.3%
5	404	22.9%
3	248	14.0%
1	14	0.8%

Space Separator

Value	Count	Frequency (%)
	5063	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	436	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	104	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	65	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	65	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	45489	84.4%
Common	8409	15.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	5358	11.8%
T	3581	7.9%
S	3389	7.5%
O	3389	7.5%
R	3275	7.2%
A	3235	7.1%
I	3091	6.8%
N	3088	6.8%
L	2356	5.2%
M	1903	4.2%
Other values (15)	12824	28.2%

Common

Value	Count	Frequency (%)
	5063	60.2%
0	1102	13.1%
:	655	7.8%
$	436	5.2%
5	404	4.8%
3	248	2.9%
/	206	2.4%
-	104	1.2%
(	65	0.8%
)	65	0.8%
Other values (4)	61	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	53898	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	5358	9.9%
	5063	9.4%
T	3581	6.6%
S	3389	6.3%
O	3389	6.3%
R	3275	6.1%
A	3235	6.0%
I	3091	5.7%
N	3088	5.7%
L	2356	4.4%
Other values (29)	18073	33.5%

Location_Description
Categorical

Distinct	73
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Memory size	25.6 KiB

STREET	799
RESIDENCE	524
SIDEWALK	427
APARTMENT	356
OTHER	108
Other values (68)	1042

Length

Max length	46
Median length	42
Mean length	10.90387
Min length	4

Characters and Unicode

Total characters	35503
Distinct characters	31
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11 ?
Unique (%)	0.3%

Sample

1st row	ALLEY
2nd row	STREET
3rd row	PARK PROPERTY
4th row	RESTAURANT
5th row	GARAGE

Common Values

Value	Count	Frequency (%)
STREET	799	24.5%
RESIDENCE	524	16.1%
SIDEWALK	427	13.1%
APARTMENT	356	10.9%
OTHER	108	3.3%
ALLEY	91	2.8%
PARKING LOT/GARAGE(NON.RESID.)	77	2.4%
RESIDENCE-GARAGE	74	2.3%
PARK PROPERTY	62	1.9%
RESIDENTIAL YARD (FRONT/BACK)	61	1.9%
Other values (63)	677	20.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
street	799	18.0%
residence	581	13.1%
sidewalk	427	9.6%
apartment	373	8.4%
store	169	3.8%
other	118	2.7%
parking	117	2.6%
alley	91	2.1%
lot/garage(non.resid	77	1.7%
residence-garage	74	1.7%
Other values (105)	1607	36.3%

Most occurring characters

Value	Count	Frequency (%)
E	5958	16.8%
T	3589	10.1%
R	3562	10.0%
A	2919	8.2%
S	2556	7.2%
I	1975	5.6%
N	1961	5.5%
L	1521	4.3%
D	1504	4.2%
C	1367	3.9%
Other values (21)	8591	24.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	33313	93.8%
Space Separator	1177	3.3%
Other Punctuation	565	1.6%
Open Punctuation	150	0.4%
Close Punctuation	150	0.4%
Dash Punctuation	148	0.4%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	5958	17.9%
T	3589	10.8%
R	3562	10.7%
A	2919	8.8%
S	2556	7.7%
I	1975	5.9%
N	1961	5.9%
L	1521	4.6%
D	1504	4.5%
C	1367	4.1%
Other values (14)	6401	19.2%

Other Punctuation

Value	Count	Frequency (%)
/	351	62.1%
.	154	27.3%
,	60	10.6%

Space Separator

Value	Count	Frequency (%)
	1177	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	150	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	150	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	148	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	33313	93.8%
Common	2190	6.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	5958	17.9%
T	3589	10.8%
R	3562	10.7%
A	2919	8.8%
S	2556	7.7%
I	1975	5.9%
N	1961	5.9%
L	1521	4.6%
D	1504	4.5%
C	1367	4.1%
Other values (14)	6401	19.2%

Common

Value	Count	Frequency (%)
	1177	53.7%
/	351	16.0%
.	154	7.0%
(	150	6.8%
)	150	6.8%
-	148	6.8%
,	60	2.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	35503	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	5958	16.8%
T	3589	10.1%
R	3562	10.0%
A	2919	8.2%
S	2556	7.2%
I	1975	5.6%
N	1961	5.5%
L	1521	4.3%
D	1504	4.2%
C	1367	3.9%
Other values (21)	8591	24.2%

Arrest
Boolean

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.3 KiB

False	2351
True	905

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	2351	72.2%
True	905	27.8%

Domestic
Boolean

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.3 KiB

False	2794
True	462

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	2794	85.8%
True	462	14.2%

Beat
Real number (ℝ)

Distinct	284
Distinct (%)	8.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1207.1625

Minimum	111
Maximum	2535
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	25.6 KiB

Quantile statistics

Minimum	111
5-th percentile	213
Q1	622
median	1111
Q3	1813
95-th percentile	2512.25
Maximum	2535
Range	2424
Interquartile range (IQR)	1191

Descriptive statistics

Standard deviation	714.15851
Coefficient of variation (CV)	0.59160099
Kurtosis	-1.0535109
Mean	1207.1625
Median Absolute Deviation (MAD)	587
Skewness	0.34337858
Sum	3930521
Variance	510022.38
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
624	29	0.9%
1834	27	0.8%
823	27	0.8%
2533	26	0.8%
1112	25	0.8%
2535	25	0.8%
431	24	0.7%
424	24	0.7%
123	24	0.7%
1021	24	0.7%
Other values (274)	3001	92.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
111	12	0.4%
112	8	0.2%
113	12	0.4%
122	17	0.5%
123	24	0.7%
124	19	0.6%
131	14	0.4%
132	21	0.6%
133	6	0.2%
134	8	0.2%

Value	Count	Frequency (%)
2535	25	0.8%
2534	11	0.3%
2533	26	0.8%
2532	18	0.6%
2531	14	0.4%
2525	4	0.1%
2524	13	0.4%
2523	6	0.2%
2522	15	0.5%
2521	11	0.3%

District
Real number (ℝ)

Distinct	22
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.347666

Minimum	1
Maximum	25
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	25.6 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	6
median	10
Q3	17
95-th percentile	25
Maximum	25
Range	24
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	7.0109513
Coefficient of variation (CV)	0.61783202
Kurtosis	-0.92697655
Mean	11.347666
Median Absolute Deviation (MAD)	5
Skewness	0.4092252
Sum	36948
Variance	49.153438
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
8	225	6.9%
6	193	5.9%
25	188	5.8%
4	185	5.7%
7	183	5.6%
11	183	5.6%
12	160	4.9%
5	160	4.9%
19	158	4.9%
9	157	4.8%
Other values (12)	1464	45.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	145	4.5%
2	145	4.5%
3	155	4.8%
4	185	5.7%
5	160	4.9%
6	193	5.9%
7	183	5.6%
8	225	6.9%
9	157	4.8%
10	138	4.2%

Value	Count	Frequency (%)
25	188	5.8%
24	85	2.6%
22	129	4.0%
20	57	1.8%
19	158	4.9%
18	147	4.5%
17	115	3.5%
16	109	3.3%
15	132	4.1%
14	107	3.3%

Ward
Real number (ℝ)

Distinct	50
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.152334

Minimum	1
Maximum	50
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	25.6 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	10
median	23
Q3	34
95-th percentile	46
Maximum	50
Range	49
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	13.980681
Coefficient of variation (CV)	0.6038562
Kurtosis	-1.116055
Mean	23.152334
Median Absolute Deviation (MAD)	12
Skewness	0.13157775
Sum	75384
Variance	195.45943
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
42	166	5.1%
2	133	4.1%
28	128	3.9%
24	124	3.8%
21	120	3.7%
34	118	3.6%
6	115	3.5%
27	112	3.4%
15	99	3.0%
20	99	3.0%
Other values (40)	2042	62.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	52	1.6%
2	133	4.1%
3	92	2.8%
4	59	1.8%
5	69	2.1%
6	115	3.5%
7	79	2.4%
8	85	2.6%
9	80	2.5%
10	70	2.1%

Value	Count	Frequency (%)
50	38	1.2%
49	33	1.0%
48	39	1.2%
47	35	1.1%
46	40	1.2%
45	37	1.1%
44	56	1.7%
43	51	1.6%
42	166	5.1%
41	27	0.8%

Community_Area
Real number (ℝ)

Distinct	77
Distinct (%)	2.4%
Missing	6
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	37.686769

Minimum	1
Maximum	77
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	25.6 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	23
median	32
Q3	57
95-th percentile	71
Maximum	77
Range	76
Interquartile range (IQR)	34

Descriptive statistics

Standard deviation	21.648008
Coefficient of variation (CV)	0.5744193
Kurtosis	-1.1429327
Mean	37.686769
Median Absolute Deviation (MAD)	17
Skewness	0.16912505
Sum	122482
Variance	468.63624
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25	200	6.1%
8	120	3.7%
23	110	3.4%
29	100	3.1%
32	100	3.1%
28	96	2.9%
49	96	2.9%
67	95	2.9%
24	94	2.9%
43	92	2.8%
Other values (67)	2147	65.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	36	1.1%
2	39	1.2%
3	43	1.3%
4	22	0.7%
5	18	0.6%
6	78	2.4%
7	54	1.7%
8	120	3.7%
9	3	0.1%
10	18	0.6%

Value	Count	Frequency (%)
77	37	1.1%
76	10	0.3%
75	30	0.9%
74	6	0.2%
73	49	1.5%
72	14	0.4%
71	87	2.7%
70	26	0.8%
69	83	2.5%
68	80	2.5%

FBI_Code
Categorical

Distinct	23
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	25.6 KiB

6	672
08B	517
18	383
26	322
14	304
Other values (18)	1058

Length

Max length	3
Median length	2
Mean length	1.8820639
Min length	1

Characters and Unicode

Total characters	6128
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	01A
2nd row	01A
3rd row	01A
4th row	01A
5th row	01A

Common Values

Value	Count	Frequency (%)
6	672	20.6%
08B	517	15.9%
18	383	11.8%
26	322	9.9%
14	304	9.3%
5	241	7.4%
08A	145	4.5%
3	143	4.4%
7	132	4.1%
11	106	3.3%
Other values (13)	291	8.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
6	672	20.6%
08b	517	15.9%
18	383	11.8%
26	322	9.9%
14	304	9.3%
5	241	7.4%
08a	145	4.5%
3	143	4.4%
7	132	4.1%
11	106	3.3%
Other values (13)	291	8.9%

Most occurring characters

Value	Count	Frequency (%)
8	1045	17.1%
6	1017	16.6%
1	1006	16.4%
0	830	13.5%
B	605	9.9%
4	464	7.6%
2	384	6.3%
5	265	4.3%
A	208	3.4%
3	143	2.3%
Other values (2)	161	2.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5315	86.7%
Uppercase Letter	813	13.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
8	1045	19.7%
6	1017	19.1%
1	1006	18.9%
0	830	15.6%
4	464	8.7%
2	384	7.2%
5	265	5.0%
3	143	2.7%
7	142	2.7%
9	19	0.4%

Uppercase Letter

Value	Count	Frequency (%)
B	605	74.4%
A	208	25.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	5315	86.7%
Latin	813	13.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
8	1045	19.7%
6	1017	19.1%
1	1006	18.9%
0	830	15.6%
4	464	8.7%
2	384	7.2%
5	265	5.0%
3	143	2.7%
7	142	2.7%
9	19	0.4%

Latin

Value	Count	Frequency (%)
B	605	74.4%
A	208	25.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6128	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
8	1045	17.1%
6	1017	16.6%
1	1006	16.4%
0	830	13.5%
B	605	9.9%
4	464	7.6%
2	384	6.3%
5	265	4.3%
A	208	3.4%
3	143	2.3%
Other values (2)	161	2.6%

X_Coordinate
Real number (ℝ)

Distinct	2993
Distinct (%)	92.0%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1164892

Minimum	1100317
Maximum	1204791
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	25.6 KiB

Quantile statistics

Minimum	1100317
5-th percentile	1138501.6
Q1	1153059.5
median	1166546
Q3	1176446.5
95-th percentile	1191318.3
Maximum	1204791
Range	104474
Interquartile range (IQR)	23387

Descriptive statistics

Standard deviation	16023.845
Coefficient of variation (CV)	0.013755648
Kurtosis	-0.16434701
Mean	1164892
Median Absolute Deviation (MAD)	11260
Skewness	-0.209957
Sum	3.7917235 × 10⁹
Variance	2.567636 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1176363	7	0.2%
1177338	6	0.2%
1150674	5	0.2%
1149512	4	0.1%
1199204	4	0.1%
1151145	4	0.1%
1143016	4	0.1%
1177483	4	0.1%
1182317	4	0.1%
1154228	4	0.1%
Other values (2983)	3209	98.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1100317	1	< 0.1%
1100726	1	< 0.1%
1101667	2	0.1%
1106851	2	0.1%
1116632	1	< 0.1%
1116977	2	0.1%
1117558	1	< 0.1%
1120736	1	< 0.1%
1121841	1	< 0.1%
1122843	1	< 0.1%

Value	Count	Frequency (%)
1204791	1	< 0.1%
1204456	1	< 0.1%
1204230	1	< 0.1%
1203829	1	< 0.1%
1202467	1	< 0.1%
1202212	1	< 0.1%
1202162	1	< 0.1%
1201989	1	< 0.1%
1201888	1	< 0.1%
1201815	1	< 0.1%

Y_Coordinate
Real number (ℝ)

Distinct	3009
Distinct (%)	92.4%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1885049.5

Minimum	1814464
Maximum	1951318
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	25.6 KiB

Quantile statistics

Minimum	1814464
5-th percentile	1832766.1
Q1	1858279.5
median	1890302
Q3	1909020
95-th percentile	1934415.7
Maximum	1951318
Range	136854
Interquartile range (IQR)	50740.5

Descriptive statistics

Standard deviation	31932.542
Coefficient of variation (CV)	0.016939896
Kurtosis	-1.0165383
Mean	1885049.5
Median Absolute Deviation (MAD)	26644
Skewness	-0.071674517
Sum	6.135836 × 10⁹
Variance	1.0196872 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1900547	6	0.2%
1910363	5	0.2%
1906181	5	0.2%
1847271	5	0.2%
1900524	4	0.1%
1900768	4	0.1%
1852629	4	0.1%
1901446	4	0.1%
1895173	4	0.1%
1900577	4	0.1%
Other values (2999)	3210	98.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1814464	1	< 0.1%
1814793	1	< 0.1%
1815106	1	< 0.1%
1817033	1	< 0.1%
1817128	1	< 0.1%
1817541	1	< 0.1%
1817559	1	< 0.1%
1817578	1	< 0.1%
1817699	1	< 0.1%
1818324	1	< 0.1%

Value	Count	Frequency (%)
1951318	1	< 0.1%
1951183	1	< 0.1%
1951001	2	0.1%
1950609	1	< 0.1%
1950574	1	< 0.1%
1950521	1	< 0.1%
1950516	1	< 0.1%
1950357	1	< 0.1%
1950346	2	0.1%
1950211	1	< 0.1%

Updated_On
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	25.6 KiB

02/04/2016 06:33:39 AM	3235
08/17/2015 03:03:40 PM	20
04/15/2016 11:16:05 AM	1

Length

Max length	22
Median length	22
Mean length	22
Min length	22

Characters and Unicode

Total characters	71632
Distinct characters	16
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	08/17/2015 03:03:40 PM
2nd row	08/17/2015 03:03:40 PM
3rd row	08/17/2015 03:03:40 PM
4th row	08/17/2015 03:03:40 PM
5th row	08/17/2015 03:03:40 PM

Common Values

Value	Count	Frequency (%)
02/04/2016 06:33:39 AM	3235	99.4%
08/17/2015 03:03:40 PM	20	0.6%
04/15/2016 11:16:05 AM	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
am	3236	33.1%
02/04/2016	3235	33.1%
06:33:39	3235	33.1%
08/17/2015	20	0.2%
03:03:40	20	0.2%
pm	20	0.2%
04/15/2016	1	< 0.1%
11:16:05	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	13043	18.2%
3	9745	13.6%
/	6512	9.1%
	6512	9.1%
:	6512	9.1%
2	6491	9.1%
6	6472	9.0%
1	3280	4.6%
4	3256	4.5%
M	3256	4.5%
Other values (6)	6553	9.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	45584	63.6%
Other Punctuation	13024	18.2%
Space Separator	6512	9.1%
Uppercase Letter	6512	9.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	13043	28.6%
3	9745	21.4%
2	6491	14.2%
6	6472	14.2%
1	3280	7.2%
4	3256	7.1%
9	3235	7.1%
5	22	< 0.1%
8	20	< 0.1%
7	20	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
M	3256	50.0%
A	3236	49.7%
P	20	0.3%

Other Punctuation

Value	Count	Frequency (%)
/	6512	50.0%
:	6512	50.0%

Space Separator

Value	Count	Frequency (%)
	6512	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	65120	90.9%
Latin	6512	9.1%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	13043	20.0%
3	9745	15.0%
/	6512	10.0%
	6512	10.0%
:	6512	10.0%
2	6491	10.0%
6	6472	9.9%
1	3280	5.0%
4	3256	5.0%
9	3235	5.0%
Other values (3)	62	0.1%

Latin

Value	Count	Frequency (%)
M	3256	50.0%
A	3236	49.7%
P	20	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	71632	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	13043	18.2%
3	9745	13.6%
/	6512	9.1%
	6512	9.1%
:	6512	9.1%
2	6491	9.1%
6	6472	9.0%
1	3280	4.6%
4	3256	4.5%
M	3256	4.5%
Other values (6)	6553	9.1%

Latitude
Real number (ℝ)

Distinct	3092
Distinct (%)	95.0%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	41.840166

Minimum	41.645647
Maximum	42.022063
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	25.6 KiB

Quantile statistics

Minimum	41.645647
5-th percentile	41.696217
Q1	41.766273
median	41.854771
Q3	41.906313
95-th percentile	41.97632
Maximum	42.022063
Range	0.37641532
Interquartile range (IQR)	0.14003986

Descriptive statistics

Standard deviation	0.087814721
Coefficient of variation (CV)	0.0020988138
Kurtosis	-1.0185297
Mean	41.840166
Median Absolute Deviation (MAD)	0.073275188
Skewness	-0.072593198
Sum	136189.74
Variance	0.0077114251
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41.89789513	5	0.2%
41.90993405	5	0.2%
41.8824572	5	0.2%
41.88548754	4	0.1%
41.73625535	4	0.1%
41.75094076	4	0.1%
41.86818094	4	0.1%
41.88375061	4	0.1%
41.78195413	3	0.1%
41.87834366	3	0.1%
Other values (3082)	3214	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
41.64564736	1	< 0.1%
41.6470384	1	< 0.1%
41.64754054	1	< 0.1%
41.65268812	1	< 0.1%
41.6530237	1	< 0.1%
41.65459014	1	< 0.1%
41.65464613	1	< 0.1%
41.65465775	1	< 0.1%
41.65501226	1	< 0.1%
41.6566536	1	< 0.1%

Value	Count	Frequency (%)
42.02206269	1	< 0.1%
42.02168201	1	< 0.1%
42.02117868	1	< 0.1%
42.02117847	1	< 0.1%
42.02010017	1	< 0.1%
42.0199755	1	< 0.1%
42.01984471	1	< 0.1%
42.01981196	1	< 0.1%
42.01947541	1	< 0.1%
42.01938122	1	< 0.1%

Longitude
Real number (ℝ)

Distinct	3092
Distinct (%)	95.0%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	-87.670452

Minimum	-87.906463
Maximum	-87.525794
Zeros	0
Zeros (%)	0.0%
Negative	3255
Negative (%)	> 99.9%
Memory size	25.6 KiB

Quantile statistics

Minimum	-87.906463
5-th percentile	-87.766656
Q1	-87.713476
median	-87.664206
Q3	-87.627851
95-th percentile	-87.574428
Maximum	-87.525794
Range	0.38066877
Interquartile range (IQR)	0.085625423

Descriptive statistics

Standard deviation	0.058303872
Coefficient of variation (CV)	-0.00066503447
Kurtosis	-0.15728514
Mean	-87.670452
Median Absolute Deviation (MAD)	0.04079073
Skewness	-0.220161
Sum	-285367.32
Variance	0.0033993415
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-87.62409661	5	0.2%
-87.72192157	5	0.2%
-87.62784778	5	0.2%
-87.72642205	4	0.1%
-87.62820806	4	0.1%
-87.62518522	4	0.1%
-87.70927139	4	0.1%
-87.75029378	4	0.1%
-87.68371315	3	0.1%
-87.61986606	3	0.1%
Other values (3082)	3214	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-87.90646315	1	< 0.1%
-87.90497627	1	< 0.1%
-87.9015144	2	0.1%
-87.88240413	2	0.1%
-87.84646896	1	< 0.1%
-87.84521442	2	0.1%
-87.8430843	1	< 0.1%
-87.83161567	1	< 0.1%
-87.82751409	1	< 0.1%
-87.82358953	1	< 0.1%

Value	Count	Frequency (%)
-87.52579439	1	< 0.1%
-87.52699812	1	< 0.1%
-87.52776812	1	< 0.1%
-87.52924215	1	< 0.1%
-87.53407165	1	< 0.1%
-87.53528171	1	< 0.1%
-87.53528375	1	< 0.1%
-87.53597409	1	< 0.1%
-87.53648659	1	< 0.1%
-87.5364904	1	< 0.1%

Location
Categorical

HIGH CARDINALITY UNIFORM

Distinct	3092
Distinct (%)	95.0%
Missing	1
Missing (%)	< 0.1%
Memory size	25.6 KiB

(41.897895128, -87.624096605)	5
(41.909934052, -87.72192157)	5
(41.882457198, -87.627847776)	5
(41.885487535, -87.726422045)	4
(41.73625535, -87.62820806)	4
Other values (3087)	3232

Length

Max length	29
Median length	29
Mean length	28.774808
Min length	26

Characters and Unicode

Total characters	93662
Distinct characters	16
Distinct categories	6 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2958 ?
Unique (%)	90.9%

Sample

1st row	(41.758275857, -87.622451031)
2nd row	(41.87025207, -87.746069362)
3rd row	(41.770990476, -87.698901469)
4th row	(41.894916924, -87.757358147)
5th row	(41.843826272, -87.709893465)

Common Values

Value	Count	Frequency (%)
(41.897895128, -87.624096605)	5	0.2%
(41.909934052, -87.72192157)	5	0.2%
(41.882457198, -87.627847776)	5	0.2%
(41.885487535, -87.726422045)	4	0.1%
(41.73625535, -87.62820806)	4	0.1%
(41.750940757, -87.625185222)	4	0.1%
(41.868180939, -87.709271389)	4	0.1%
(41.883750613, -87.750293777)	4	0.1%
(41.781954133, -87.683713146)	3	0.1%
(41.878343664, -87.619866061)	3	0.1%
Other values (3082)	3214	98.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
41.897895128	5	0.1%
41.909934052	5	0.1%
87.72192157	5	0.1%
41.882457198	5	0.1%
87.627847776	5	0.1%
87.624096605	5	0.1%
87.625185222	4	0.1%
87.750293777	4	0.1%
41.883750613	4	0.1%
87.709271389	4	0.1%
Other values (6174)	6464	99.3%

Most occurring characters

Value	Count	Frequency (%)
7	10466	11.2%
8	9586	10.2%
1	8313	8.9%
4	8295	8.9%
6	7345	7.8%
.	6510	7.0%
9	6101	6.5%
5	5611	6.0%
2	5334	5.7%
3	5186	5.5%
Other values (6)	20915	22.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	70877	75.7%
Other Punctuation	9765	10.4%
Open Punctuation	3255	3.5%
Space Separator	3255	3.5%
Dash Punctuation	3255	3.5%
Close Punctuation	3255	3.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
7	10466	14.8%
8	9586	13.5%
1	8313	11.7%
4	8295	11.7%
6	7345	10.4%
9	6101	8.6%
5	5611	7.9%
2	5334	7.5%
3	5186	7.3%
0	4640	6.5%

Other Punctuation

Value	Count	Frequency (%)
.	6510	66.7%
,	3255	33.3%

Open Punctuation

Value	Count	Frequency (%)
(	3255	100.0%

Space Separator

Value	Count	Frequency (%)
	3255	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3255	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	3255	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	93662	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
7	10466	11.2%
8	9586	10.2%
1	8313	8.9%
4	8295	8.9%
6	7345	7.8%
.	6510	7.0%
9	6101	6.5%
5	5611	6.0%
2	5334	5.7%
3	5186	5.5%
Other values (6)	20915	22.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	93662	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
7	10466	11.2%
8	9586	10.2%
1	8313	8.9%
4	8295	8.9%
6	7345	7.8%
.	6510	7.0%
9	6101	6.5%
5	5611	6.0%
2	5334	5.7%
3	5186	5.5%
Other values (6)	20915	22.3%

Auto

Heatmap
Table

	ID	Beat	District	Ward	Community_Area	X_Coordinate	Y_Coordinate	Latitude	Longitude	Primary_Type	Location_Description	Arrest	Domestic	FBI_Code	Updated_On
ID	1.000	-0.012	-0.009	0.021	-0.014	0.045	-0.002	-0.002	0.045	0.997	0.488	0.030	0.000	0.997	1.000
Beat	-0.012	1.000	0.926	0.604	-0.541	-0.546	0.641	0.642	-0.540	0.086	0.112	0.126	0.083	0.080	0.023
District	-0.009	0.926	1.000	0.670	-0.539	-0.626	0.649	0.650	-0.621	0.089	0.109	0.132	0.088	0.084	0.028
Ward	0.021	0.604	0.670	1.000	-0.559	-0.441	0.635	0.635	-0.435	0.095	0.125	0.102	0.083	0.090	0.009
Community_Area	-0.014	-0.541	-0.539	-0.559	1.000	0.342	-0.819	-0.819	0.331	0.089	0.125	0.130	0.112	0.083	0.009
X_Coordinate	0.045	-0.546	-0.626	-0.441	0.342	1.000	-0.559	-0.562	1.000	0.049	0.280	0.082	0.033	0.050	0.000
Y_Coordinate	-0.002	0.641	0.649	0.635	-0.819	-0.559	1.000	1.000	-0.546	0.072	0.106	0.101	0.105	0.071	0.043
Latitude	-0.002	0.642	0.650	0.635	-0.819	-0.562	1.000	1.000	-0.549	0.072	0.106	0.092	0.107	0.071	0.044
Longitude	0.045	-0.540	-0.621	-0.435	0.331	1.000	-0.546	-0.549	1.000	0.049	0.280	0.083	0.032	0.049	0.000
Primary_Type	0.997	0.086	0.089	0.095	0.089	0.049	0.072	0.072	0.049	1.000	0.204	0.712	0.526	0.899	0.705
Location_Description	0.488	0.112	0.109	0.125	0.125	0.280	0.106	0.106	0.280	0.204	1.000	0.338	0.360	0.209	0.330
Arrest	0.030	0.126	0.132	0.102	0.130	0.082	0.101	0.092	0.083	0.712	0.338	1.000	0.084	0.685	0.041
Domestic	0.000	0.083	0.088	0.083	0.112	0.033	0.105	0.107	0.032	0.526	0.360	0.084	1.000	0.534	0.000
FBI_Code	0.997	0.080	0.084	0.090	0.083	0.050	0.071	0.071	0.049	0.899	0.209	0.685	0.534	1.000	0.706
Updated_On	1.000	0.023	0.028	0.009	0.009	0.000	0.043	0.044	0.000	0.705	0.330	0.041	0.000	0.706	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	ID	Case_Number	Date	Block	IUCR	Primary_Type	Description	Location_Description	Arrest	Domestic	Beat	District	Ward	Community_Area	FBI_Code	X_Coordinate	Y_Coordinate	Updated_On	Latitude	Longitude	Location
0	4785	HP610824	10/07/2008 12:39:00 PM	000XX E 75TH ST	110	HOMICIDE	FIRST DEGREE MURDER	ALLEY	True	False	323	3.0	6.0	69.0	01A	1178207.0	1855308.0	08/17/2015 03:03:40 PM	41.758276	-87.622451	(41.758275857, -87.622451031)
1	4786	HP616595	10/09/2008 03:30:00 AM	048XX W POLK ST	110	HOMICIDE	FIRST DEGREE MURDER	STREET	True	False	1533	15.0	24.0	25.0	01A	1144200.0	1895857.0	08/17/2015 03:03:40 PM	41.870252	-87.746069	(41.87025207, -87.746069362)
2	4787	HP616904	10/09/2008 08:35:00 AM	030XX W MANN DR	110	HOMICIDE	FIRST DEGREE MURDER	PARK PROPERTY	False	False	831	8.0	18.0	66.0	01A	1157314.0	1859778.0	08/17/2015 03:03:40 PM	41.770990	-87.698901	(41.770990476, -87.698901469)
3	4788	HP618616	10/10/2008 02:33:00 AM	052XX W CHICAGO AVE	110	HOMICIDE	FIRST DEGREE MURDER	RESTAURANT	False	False	1524	15.0	37.0	25.0	01A	1141065.0	1904824.0	08/17/2015 03:03:40 PM	41.894917	-87.757358	(41.894916924, -87.757358147)
4	4789	HP619020	10/10/2008 12:50:00 PM	026XX S HOMAN AVE	110	HOMICIDE	FIRST DEGREE MURDER	GARAGE	False	True	1032	10.0	22.0	30.0	01A	1154123.0	1886297.0	08/17/2015 03:03:40 PM	41.843826	-87.709893	(41.843826272, -87.709893465)
5	4790	HP620131	10/10/2008 08:32:00 PM	015XX W 14TH ST	110	HOMICIDE	FIRST DEGREE MURDER	STREET	True	True	1231	12.0	2.0	28.0	01A	1166321.0	1893492.0	08/17/2015 03:03:40 PM	41.863318	-87.664924	(41.863318307, -87.664923682)
6	4791	HP620406	10/11/2008 12:55:00 AM	020XX W 23RD ST	110	HOMICIDE	FIRST DEGREE MURDER	STREET	True	False	1034	10.0	25.0	31.0	01A	1163192.0	1888742.0	08/17/2015 03:03:40 PM	41.850350	-87.676543	(41.850350125, -87.676543351)
7	4792	HP622040	10/11/2008 10:25:00 PM	069XX S PAXTON AVE	110	HOMICIDE	FIRST DEGREE MURDER	STREET	False	False	331	3.0	5.0	43.0	01A	1192078.0	1859337.0	08/17/2015 03:03:40 PM	41.769006	-87.571485	(41.769005966, -87.571485086)
8	4793	HP622164	10/11/2008 10:00:00 PM	060XX S SAWYER AVE	110	HOMICIDE	FIRST DEGREE MURDER	PORCH	False	False	823	8.0	16.0	66.0	01A	1155755.0	1864457.0	08/17/2015 03:03:40 PM	41.783862	-87.704491	(41.783861768, -87.704490821)
9	4794	HP622189	10/12/2008 05:47:00 AM	024XX W 51ST ST	110	HOMICIDE	FIRST DEGREE MURDER	ALLEY	False	False	911	9.0	14.0	63.0	01A	1160775.0	1870785.0	08/17/2015 03:03:40 PM	41.801124	-87.685911	(41.801124416, -87.685910818)

	ID	Case_Number	Date	Block	IUCR	Primary_Type	Description	Location_Description	Arrest	Domestic	Beat	District	Ward	Community_Area	FBI_Code	X_Coordinate	Y_Coordinate	Updated_On	Latitude	Longitude	Location
3246	7588403	HS392450	07/03/2010 05:21:00 PM	037XX N RICHMOND ST	486	BATTERY	DOMESTIC BATTERY SIMPLE	APARTMENT	False	True	1733	17.0	33.0	16.0	08B	1156052.0	1924747.0	02/04/2016 06:33:39 AM	41.949298	-87.701776	(41.949297934, -87.701775686)
3247	7588404	HS392466	07/03/2010 05:45:00 PM	011XX N LOCKWOOD AVE	2027	NARCOTICS	POSS: CRACK	ALLEY	True	False	1524	15.0	37.0	25.0	18	1140813.0	1907182.0	02/04/2016 06:33:39 AM	41.901392	-87.758226	(41.901392194, -87.758225634)
3248	7588405	HS387923	07/01/2010 12:00:00 AM	020XX E 75TH ST	820	THEFT	$500 AND UNDER	STREET	False	False	414	4.0	8.0	43.0	6	1191290.0	1855646.0	02/04/2016 06:33:39 AM	41.758897	-87.574493	(41.758896683, -87.574492818)
3249	7588406	HS392340	07/03/2010 03:05:00 PM	016XX N CLYBOURN AVE	820	THEFT	$500 AND UNDER	STREET	False	False	1813	18.0	32.0	7.0	6	1170214.0	1911024.0	02/04/2016 06:33:39 AM	41.911343	-87.650120	(41.911343228, -87.65012046)
3250	7588407	HS389015	07/01/2010 01:45:00 PM	050XX W WEST END AVE	2825	OTHER OFFENSE	HARASSMENT BY TELEPHONE	RESIDENCE	False	True	1532	15.0	28.0	25.0	26	1142756.0	1900513.0	02/04/2016 06:33:39 AM	41.883056	-87.751255	(41.883055705, -87.751254884)
3251	7588408	HS392526	07/03/2010 06:30:00 PM	014XX W 63RD ST	2093	NARCOTICS	FOUND SUSPECT NARCOTICS	POLICE FACILITY/VEH PARKING LOT	True	False	713	7.0	16.0	67.0	26	1167639.0	1862965.0	02/04/2016 06:33:39 AM	41.779521	-87.660962	(41.779520772, -87.660962362)
3252	7588411	HS392229	07/03/2010 02:50:00 PM	016XX N KEELER AVE	486	BATTERY	DOMESTIC BATTERY SIMPLE	APARTMENT	False	True	2534	25.0	30.0	23.0	08B	1148137.0	1910578.0	02/04/2016 06:33:39 AM	41.910573	-87.731236	(41.91057328, -87.731236005)
3253	7588412	HS392515	07/03/2010 09:00:00 AM	053XX S CAMPBELL AVE	1150	DECEPTIVE PRACTICE	CREDIT CARD FRAUD	RESIDENCE	False	False	911	9.0	14.0	63.0	11	1160608.0	1869235.0	02/04/2016 06:33:39 AM	41.796874	-87.686566	(41.796874465, -87.686566039)
3254	7588413	HS392455	07/03/2010 05:15:00 PM	030XX N ODELL AVE	486	BATTERY	DOMESTIC BATTERY SIMPLE	RESIDENCE	False	True	2511	25.0	36.0	17.0	08B	1126558.0	1919423.0	02/04/2016 06:33:39 AM	41.935233	-87.810313	(41.935233424, -87.81031254)
3255	7588414	HS392521	07/03/2010 06:10:00 PM	051XX W BELDEN AVE	1310	CRIMINAL DAMAGE	TO PROPERTY	STREET	False	False	2522	25.0	31.0	19.0	14	1141544.0	1914802.0	02/04/2016 06:33:39 AM	41.922289	-87.755352	(41.922288839, -87.75535195)

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category